package com.wlf.Mapper;

import com.wlf.Entity.SalesForecastTable;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ExcelMapper{

    //获取数据库中数据
    @Select("select *from salesforecasts")
    List<SalesForecastTable> getAll();

    //清空数据库SalesForecastTable表中数据
    @Delete("delete from salesforecasts")
    void deleteInfo();

    //保存到数据库
    int saveList(@Param("list") List<SalesForecastTable> salesForecastTables);

}
